﻿CREATE TABLE [plate].[PlateType] (
    [PlateTypeID]         INT           IDENTITY (1, 1) NOT NULL,
    [Value]               VARCHAR (50)  NULL,
    [Description]         VARCHAR (500) NULL,
    [PlateSequenceTypeID] INT           NULL,
    [CreatedBy]           VARCHAR (50)  NULL,
    [CreatedDate]         DATETIME      NULL,
    [UpdatedBy]           VARCHAR (50)  NULL,
    [UpdatedDate]         DATETIME      NULL,
    [EndDate]             DATETIME      NULL,
    CONSTRAINT [PK_PlateType] PRIMARY KEY CLUSTERED ([PlateTypeID] ASC),
    CONSTRAINT [FK_PlateType_PlateSequenceType] FOREIGN KEY ([PlateSequenceTypeID]) REFERENCES [plate].[PlateSequenceType] ([PlateSequenceTypeID])
);

